package com.vsked.tests;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

import com.vsked.bean.Column;
import com.vsked.bean.ConnectionInfo;
import com.vsked.bean.ForeignKey;
import com.vsked.classMssqls.MssqlSon;
import com.vsked.connection.ConnectionUtil;
import com.vsked.database.ColumnInfo;
import com.vsked.database.TableInfo;
import com.vsked.util.TransFormDataType;

public class MytestTwo {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		try {
			ConnectionInfo ci = new ConnectionInfo();
			ci.setDbName("metaldb");
			ci.setDbPort(3306);
			ci.setDriverStr("org.gjt.mm.mysql.Driver");
			ci.setServerAddr("localhost");
			ci.setUserName("root");
			ci.setUserPass("SqlMsde@InfoxEie2000");
			ci.setDbType("MySql");
			List<String> dbNameList=new TableInfo().getMysqlTableName(ci);
			for(int i=0;i<dbNameList.size();i++){
				//System.out.println(dbNameList.get(i));
				ColumnInfo.getTableColumnNameAndDataType(ci, dbNameList.get(i));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}// end main

}
